<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title>Snomed Categories</title>
    <meta http-equiv="content-type" content="text/html; charset=Cp1252">
    <style type="text/css">
      body { font-family: verdana, arial, helvetica, sans-serif;
             font-size: smaller; }
      h1 { font-size: large; }
      tr { font-size: smaller; }
      th, td { border-left: 1px solid #000000;
               border-bottom: 1px solid #000000; padding: 2px; }
      th { color: #000000; background: #e9e9f2; }
      table { padding: 0px;  margin: 0px;
              border-top: 1px solid #000000;
              border-right: 1px solid #000000; }
      table.info { color: #000000; background: #e9e9f2; }
      table.data { color: #000000; background: #ffffff; }
      td.label { text-align: right; }
      td.value { font-weight: bold; }
      tr.even { color: #000000; background: #ffffff; }
      tr.odd { color: #000000; background: #eeeeee; }
    </style>
  </head>
  <body>
    <h1>Snomed Categories</h1>
    <p>
      The categories of SnomedCT.
    </p>
    <table class="info" cellspacing="0">
      <tr>
        <td class="label">Date:</td>
        <td class="value"><b>2011-03-31 23:12:52</b></td>
      </tr>
      <tr>
        <td class="label">Rows:</td>
        <td class="value"><b>41</b></td>
      </tr>
      <tr>
        <td class="label">Columns:</td>
        <td class="value"><b>2</b></td>
      </tr>
      <tr>
        <td>SQL Statement:</td>
        <td>
          <b><pre>select concepts.category,count(*) as total from  snomedes.concepts group by concepts.category order by total desc</pre></b>
        </td>
      </tr>
    </table>
    <br>
    <table class="data" cellspacing="0">
      <tr>
        <th>category</th>
        <th>total</th>
      </tr>
      <tr class="even">
        <td>disorder</td>
        <td align="right">92330->64162</td>
      </tr>
      <tr class="odd">
        <td>procedure</td>
        <td align="right">72013->48893</td>
      </tr>
      <tr class="even">
        <td>finding</td>
        <td align="right">44770->32977</td>
      </tr>
      <tr class="odd">
        <td>organism</td>
        <td align="right">34783->32015</td>
      </tr>
      <tr class="even">
        <td>body structure</td>
        <td align="right">26906->25638</td>
      </tr>
      <tr class="odd">
        <td>substance</td>
        <td align="right">25561->23718</td>
      </tr>
      <tr class="even">
        <td>product</td>
        <td align="right">24009->17053</td>
      </tr>
      <tr class="odd">
        <td>qualifier value</td>
        <td align="right">9903</td>
      </tr>
      <tr class="even">
        <td>event</td>
        <td align="right">8875</td>
      </tr>
      <tr class="odd">
        <td>observable entity</td>
        <td align="right">8673</td>
      </tr>
      <tr class="even">
        <td>situation</td>
        <td align="right">8184</td>
      </tr>
      <tr class="odd">
        <td>occupation</td>
        <td align="right">6449</td>
      </tr>
      <tr class="even">
        <td>morphologic abnormality</td>
        <td align="right">5075</td>
      </tr>
      <tr class="odd">
        <td>physical object</td>
        <td align="right">5043</td>
      </tr>
      <tr class="even">
        <td>regime&#47;therapy</td>
        <td align="right">3970</td>
      </tr>
      <tr class="odd">
        <td>specimen</td>
        <td align="right">1328</td>
      </tr>
      <tr class="even">
        <td>environment</td>
        <td align="right">1241</td>
      </tr>
      <tr class="odd">
        <td>unknow</td>
        <td align="right">1162</td>
      </tr>
      <tr class="even">
        <td>attribute</td>
        <td align="right">1157</td>
      </tr>
      <tr class="odd">
        <td>assessment scale</td>
        <td align="right">983</td>
      </tr>
      <tr class="even">
        <td>cell</td>
        <td align="right">628</td>
      </tr>
      <tr class="odd">
        <td>person</td>
        <td align="right">627</td>
      </tr>
      <tr class="even">
        <td>geographic location</td>
        <td align="right">610</td>
      </tr>
      <tr class="odd">
        <td>cell structure</td>
        <td align="right">514</td>
      </tr>
      <tr class="even">
        <td>navigational concept</td>
        <td align="right">487</td>
      </tr>
      <tr class="odd">
        <td>ethnic group</td>
        <td align="right">365</td>
      </tr>
      <tr class="even">
        <td>record artifact</td>
        <td align="right">294</td>
      </tr>
      <tr class="odd">
        <td>tumor staging</td>
        <td align="right">259</td>
      </tr>
      <tr class="even">
        <td>religion&#47;philosophy</td>
        <td align="right">226</td>
      </tr>
      <tr class="odd">
        <td>physical force</td>
        <td align="right">178</td>
      </tr>
      <tr class="even">
        <td>namespace concept</td>
        <td align="right">121</td>
      </tr>
      <tr class="odd">
        <td>administrative concept</td>
        <td align="right">75</td>
      </tr>
      <tr class="even">
        <td>staging scale</td>
        <td align="right">40</td>
      </tr>
      <tr class="odd">
        <td>special concept</td>
        <td align="right">31</td>
      </tr>
      <tr class="even">
        <td>life style</td>
        <td align="right">30</td>
      </tr>
      <tr class="odd">
        <td>social concept</td>
        <td align="right">27</td>
      </tr>
      <tr class="even">
        <td>racial group</td>
        <td align="right">21</td>
      </tr>
      <tr class="odd">
        <td>link assertion</td>
        <td align="right">8</td>
      </tr>
      <tr class="even">
        <td>inactive concept</td>
        <td align="right">7</td>
      </tr>
      <tr class="odd">
        <td>linkage concept</td>
        <td align="right">1</td>
      </tr>
      <tr class="even">
        <td>environment &#47; location</td>
        <td align="right">1</td>
      </tr>
    </table>
    <p><i>[ Generated by: DbVisualizer Personal 7.1.3 - <a href="http://www.dbvis.com">http://www.dbvis.com</a> ]</i></p>
    <hr>
  </body>
</html>
